<meta http-equiv=refresh content="1">
<style>
table {font-size:10px;border-spacing:2px;}
td {font-size:15px;font-family:arial;background-color:#D6E9F8;padding:0px;}
th {font-size:15px;font-family:arial;background-color:#D6E9F8;padding:0px;font-weight:bold}
a:link, a:visited, a:active	{	color: black;	background-color: #D6E9F8;	text-decoration:none;	}
h1 {font-size:20px;font-family:arial}
</style>

<?php
require_once("include.php");

$sql = "
select employee.itemid,employee.name,
jobid,processid,pgroupid,starttime
from employee
left outer join (select * from work where starttime=endtime and processid <> 'ATT' ) t2
on (employee.itemid = t2.empid)
" ;
$l = sqlreadarray($sql);


echo "<table>";
echo "<tr><th>ID</th><th>Name</th><th>Job</th><th>Station</th><th>Group</th><th>Started</th></tr>";
for ($i =0 ;$i < sizeof($l);$i++) {
 echo "<tr>";
 for ($j=0;$j < sizeof($l[$j]);$j++) {
  echo "<td>".$l[$i][$j]."</td>";
 }
 echo "</tr>";
}
echo "</table>";

?>
